exec MASTER.DBO.LX_KILL_USERS 'TNG_BKP'
RESTORE DATABASE [TNG_BKP] FROM  DISK = N'\\TNGSRV01\Backup\TNG.BKP' WITH  FILE = 1,  NOUNLOAD ,  STATS = 10,  RECOVERY ,  REPLACE ,  MOVE N'TNG_Data' TO N'D:\program files\Microsoft SQL Server\MSSQL\DataTNG_BKP.mdf',  MOVE N'TNG_Log' TO N'D:\Program Files\Microsoft SQL Server\MSSQL\Data\TNG_BKP_log.ldf'